Database Explorer

The Database Explorer allows you to view, query, and manage local database connections directly within Suite without needing external tools.

Supported Databases

• SQLite: Connect to local `.sqlite` or `.db` files on your machine.
• PostgreSQL: Connect to a local or remote PostgreSQL instance via connection string.
• MySQL/MariaDB: Connect via standard credentials and connection strings.

Features

• Connection Manager: Easily add new database connections using the Connect DB button in the top right.
• Visual Schema: Explore tables, views, and indexes through a clean tree-view interface.
• Query Execution: Open a new SQL editor tab, write your queries with full syntax highlighting, and execute them to see results in a rich data grid.
• Data Editing: Modify table contents directly from the data grid without writing `UPDATE` statements manually.

[!NOTE] Connection Strings: When connecting to Postgres or MySQL, use standard URI formats (e.g., `postgresql://user:password@localhost:5432/mydb`). For SQLite, provide the absolute path to the database file.